﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data ;
using System.Configuration;

namespace ReclutamientoCosea
{

    public static class PersonaIntranet
    {
        private static AppSettingsReader settings = new AppSettingsReader();
        public static DataSet ObtenPersonaIntranet()
        {
            DataSet ds = new DataSet();

            Conectividad db = Conectividad.Create();
            db.conexion((string)settings.GetValue("bdMySql", typeof(string)),
                (string)settings.GetValue("UserMySql", typeof(string)),
                (string)settings.GetValue("PassMySql", typeof(string)),
                (string)settings.GetValue("SrvMySql", typeof(string)));

            ds = db.fnSelect("select * from persona;", "persona");

            db.desconectar();

            return ds;
        }
    }
}
